Customer
BSH is a global manufacturer of household appliances, being a leader at national and European level with more than 40 manufacturing plants worldwide, in addition to having a significant market share worldwide. Its production is focused on the commercial brands Bosch, Siemens, Balay, Gaggenau and Neff.
Challenge
BSH needed a solution to integrate the data coming from the quality certificates issued by its raw material suppliers, as these certificates were stored in PDF in different factories.
This complicated quick access to these certificates when they needed to be consulted, so a system was proposed that would process, extract and integrate all the PDF data and allow easy and centralized access at any time.
Results
- Agile, fast and integrated access to raw material quality data, avoiding repetitive and costly tasks such as consulting PDFs in the traditional way.
- Monitoring and analyzing the quality of the raw material received and obtaining conclusions much more quickly and correctly, as well as facilitating the investigation of possible causes of raw material defects in a direct and efficient way.
- Possibility of labeling the raw material according to its performance in the factory.
Solution
The solution consists of:
- Automatic processing of the certificates sent by the supplier to our customer.
- Automatic process of extracting the most relevant data for the business of each certificate and storing them in a centralized database.
- Generation of Excel files with the processed data to facilitate access to the users involved.
- Application for visualization of stored certificates with the possibility of categorizing them into good or bad according to the performance of the raw material in the manufacturing line.
- Access control to the application through Microsoft Active Directory based on Internet Information Services.
- Automatic sending of e-mails to application users with monthly certificate tagging statistics.
The data used in this solution are:
- Data extracted from the certificates sent by raw material suppliers, which are originally in PDF format.
The technology used for this solution is based on:
- R.
- Shiny
- Microsoft SQL Server
- Microsoft Excel
- Microsoft Active Directory
- Internet Information Services
Testimonial
César San Julián Sala
Head of Supplier Development at BSH Electrodomésticos España.
“Always agile, flexible and responsive with solutions. From the beginning of the project PredictLand has shown a totally customer-oriented approach – keep it up!”
